package com.billing.model.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.billing.model.entity.TSchedulingdetails;

public interface SchedulingdetailsBeanMapper {

	/**
	 * 根据年月日获取考勤信息
	 * @param year
	 * @param month
	 * @param day
	 * @return
	 */
	public TSchedulingdetails getTSchedulingdetailsDesc(@Param("year")int year,
			@Param("month")int month,@Param("day")int day,@Param("schedulingId")int schedulingId);
	/**
	 * 根据年月日获取考勤信息
	 * @param year
	 * @param month
	 * @param day
	 * @return
	 */
	public TSchedulingdetails getTSchedulingdetailsAsc(@Param("year")int year,
			@Param("month")int month,@Param("day")int day,@Param("schedulingId")int schedulingId);
	/**
	 * 根据年月日获取考勤信息
	 * @param year
	 * @param month
	 * @param day
	 * @return
	 */
	public List<TSchedulingdetails> getTSchedulingdetailsList(@Param("year")int year,
			@Param("month")int month,@Param("day")int day,@Param("schedulingId")int schedulingId);
	
	/**
	 * 根据id获取考勤信息
	 * @return
	 */
	public TSchedulingdetails getTSchedulingdetailsById(@Param("id")int id);
	
	/**
	 * 批量新增考勤月份日期
	 * @param list
	 * @return
	 */
	public int insertTSchedulingdetailsList(@Param("lslist")List<TSchedulingdetails> lslist);
	/**
	 * 根据年和班次获取考勤信息
	 * @param year
	 * @param month
	 * @param day
	 * @return
	 */
	public List<TSchedulingdetails> getTSchedulingdetailsYear(@Param("year")int year,@Param("shiftid")int shiftid);
	/**
	 * 根据ID和年份删除排班明细信息
	 * @param id
	 * @return
	 */
	public int deleteTSchedulingdetails(@Param("id")int id,@Param("year")int year);
	/**
	 * 根据年和排班id获取考勤信息
	 * @param year
	 * @param month
	 * @param day
	 * @return
	 */
	public List<TSchedulingdetails> getTSchedulingdetailsByYear(@Param("year")int year,@Param("scheid")int scheid);
	/**
	 * 根据排班id获取考勤信息
	 * @param year
	 * @param month
	 * @param day
	 * @return
	 */
	public List<TSchedulingdetails> getTSchedulingdetailsByscheid(@Param("scheid")int scheid);
	/**
	 * 根据排班ID删除排班明细信息
	 * @param id
	 * @return
	 */
	public int deleteTSchedulingdetailsByid(@Param("id")int id);
}
